<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/md5.asp"-->
<!--#include file="../common/admin.asp"-->
<%
id=request.QueryString("id")
if id<>"" then
	set rs=server.CreateObject("adodb.recordset")
	sql="select * from hotproduct where id="&id&""
	rs.open sql,conn,1,3
	if not rs.eof then
	     title=rs("title")
		 typevalue=rs("type")
		 AuctionID=rs("AuctionID")
		 pic=rs("pic")
		 sort=rs("sort")
		 price=rs("price")
	rs.close
	set rs=nothing
	end if
end if
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>add</title>
<link href="../css/style.css" rel="stylesheet" type="text/css"/>
<style>body {background-color: #eaece1;}</style>
</head>

<body>
<div class="main">
  <div class="main-title">操作</div>
  <div class="main-content">
  <%if id<>"" then%>
  <table width="100%" border="0" cellspacing="1" cellpadding="3" class="tab">
  <form action="" method="post">
  <tr>
    <td width="21%" bgcolor="#FFFFFF">标题</td>
    <td width="79%" bgcolor="#FFFFFF"><input name="title" type="text" class="input" id="title" value="<%=title%>" /></td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF">类目</td>
    <td bgcolor="#FFFFFF"><select name="typevalue" id="typevalue">
    <%
					  set rsm=server.CreateObject("adodb.recordset")
					  sql="select * from hot where fid=0"
					  rsm.open sql,conn,1,3
					  if not rsm.eof then
					  do while not rsm.eof
					  %>
      <option value="<%=rsm("id")%>"<%if typevalue=rsm("id") then response.Write " selected"%>><%=rsm("title")%></option>
       <%
					  rsm.movenext
					  loop
					  rsm.close
					  set rsm=nothing
					  end if		 
					  %>
    </select></td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF">图片路径</td>
    <td bgcolor="#FFFFFF"><input name="pic" type="text" class="input" id="pic" value="<%=pic%>" /></td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF">竞拍号</td>
    <td bgcolor="#FFFFFF"><input name="AuctionID" type="text" class="input" id="AuctionID" value="<%=AuctionID%>" /></td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF">序号</td>
    <td bgcolor="#FFFFFF"><input name="sort" type="text" class="input" id="sort" value="<%=sort%>" /></td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF">价格</td>
    <td bgcolor="#FFFFFF"><input name="price" type="text" class="input" value="<%=price%>" />日元</td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF">&nbsp;</td>
    <td bgcolor="#FFFFFF"><input type="submit" name="button" id="button" value="保存" />
      </td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF">&nbsp;</td>
    <td bgcolor="#FFFFFF">&nbsp;</td>
    </tr>
  <tr>
    <td bgcolor="#FFFFFF">&nbsp;</td>
    <td bgcolor="#FFFFFF">&nbsp;</td>
    </tr>
  <tr>
    <td bgcolor="#FFFFFF">&nbsp;</td>
    <td bgcolor="#FFFFFF">&nbsp;</td>
    </tr>
    </form>
  </table>
  <%else%>
  <table width="100%" border="0" cellspacing="1" cellpadding="3" class="tab">
  <form action="" method="post">
  <tr>
    <td width="21%" bgcolor="#FFFFFF">标题</td>
    <td width="79%" bgcolor="#FFFFFF"><input name="title" type="text" class="input" id="title" /></td>
  </tr>
    <tr>
    <td bgcolor="#FFFFFF">类目</td>
    <td bgcolor="#FFFFFF"><select name="typevalue" id="typevalue">
    <%
					  set rsm=server.CreateObject("adodb.recordset")
					  sql="select * from hot where fid=0"
					  rsm.open sql,conn,1,3
					  if not rsm.eof then
					  do while not rsm.eof
					  %>
      <option value="<%=rsm("id")%>"><%=rsm("title")%></option>
       <%
					  rsm.movenext
					  loop
					  rsm.close
					  set rsm=nothing
					  end if		 
					  %>
    </select></td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF">图片路径</td>
    <td bgcolor="#FFFFFF"><input name="pic" type="text" class="input" id="pic" /></td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF">竞拍号</td>
    <td bgcolor="#FFFFFF"><input name="AuctionID" type="text" class="input" id="AuctionID" value="" /></td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF">序号</td>
    <td bgcolor="#FFFFFF"><input name="sort" type="text" class="input" id="sort" value="" /></td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF">价格</td>
    <td bgcolor="#FFFFFF"><input name="price" type="text" class="input" value="" />日元</td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF">&nbsp;</td>
    <td bgcolor="#FFFFFF"><input type="submit" name="button" id="button" value="添加" />
      </td>
  </tr>
  <tr>
    <td bgcolor="#FFFFFF">&nbsp;</td>
    <td bgcolor="#FFFFFF">&nbsp;</td>
    </tr>
  <tr>
    <td bgcolor="#FFFFFF">&nbsp;</td>
    <td bgcolor="#FFFFFF">&nbsp;</td>
    </tr>
  <tr>
    <td bgcolor="#FFFFFF">&nbsp;</td>
    <td bgcolor="#FFFFFF">&nbsp;</td>
    </tr>
    </form>
  </table>
  <%end if%>
</div>
</div>
</body>
</html>
<%
if request.Form("button")="添加" then

	  title=request.Form("title")
	  typevalue=request.Form("typevalue")
	  pic=request.Form("pic")
	  AuctionID=request.Form("AuctionID")
	  sort=request.Form("sort")
	  price=request.Form("price")

	  if title="" or pic="" or typevalue="" or AuctionID="" or sort="" or price="" then
	  response.write"<script>alert('标题、类目、不能为空');</script>"
	  response.write"<script>window.history.back(-1);</script>"
	  response.end
	  end if
	  
	  set rsx=server.createobject("adodb.recordset")
	  sql="select * from hotproduct"
	  rsx.open sql,conn,1,3
	  rsx.addnew
	  rsx("title")=title
	  rsx("type")=typevalue
	  rsx("pic")=pic
	  rsx("AuctionID")=AuctionID
	  rsx("sort")=sort
	  rsx("price")=price
	  rsx.update
	  response.write"<script language=JavaScript>{window.alert('添加成功！');window.location.href='view.asp';}</script>"
	  rsx.close
	  set rsx=nothing

elseif request.Form("button")="保存" then

	  title=request.Form("title")
	  typevalue=request.Form("typevalue")
	  pic=request.Form("pic")
	  AuctionID=request.Form("AuctionID")
	  sort=request.Form("sort")
	  price=request.Form("price")

	  if title="" or pic="" or typevalue="" or AuctionID="" or sort="" or price="" then
	  response.write"<script>alert('标题、类目不能为空');</script>"
	  response.write"<script>window.history.back(-1);</script>"
	  response.end
	  end if
	  
	  set rsx=server.createobject("adodb.recordset")
	  sql="select * from hotproduct where id="&id&""
	  rsx.open sql,conn,1,3
	  rsx("title")=title
	  rsx("type")=typevalue
	  rsx("pic")=pic
	  rsx("AuctionID")=AuctionID
	  rsx("sort")=sort
	  rsx("price")=price
	  rsx.update
	  response.write"<script language=JavaScript>{window.alert('保存成功！');window.location.href='add.asp?id="&id&"';}</script>"
	  rsx.close
	  set rsx=nothing
end if
%>